if not exists(select * from [STATE])
BEGIN
SET identity_insert STATE on
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Alabama',4,'AL','You probably already know that Alabama is known as the Heart of Dixie. You may already know that the state capital is Montgomery. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Alaska',3,'AK','You probably already know that Alaska is known as the Last Frontier. You may already know that the state capital is Juneau. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Arizona',7,'AZ','You probably already know that Arizona is known as the Grand Canyon State. You may already know that the state capital is Phoenix. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Arkansas',6,'AR','You probably already know that Arkansas is known as the Natural State. You may already know that the state capital is Little Rock. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('California',8,'CA','You probably already know that California is known as the Golden State. You may already know that the state capital is Sacramento. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Colorado',9,'CO','You probably already know that Colorado is known as the Centennial State. You may already know that the state capital is Denver. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Connecticut',10,'CT','You probably already know that Connecticut is known as the Constitution State. You may already know that the state capital is Hartford. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Delaware',12,'DE','You probably already know that Delaware is known as the First State. You may already know that the state capital is Dover. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('District Of Columbia',11,'DC','You probably already know that the District of Columbia is known as Federal City. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Florida',13,'FL','You probably already know that Florida is known as the Sunshine State. You may already know that the state capital is Tallahassee. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Georgia',14,'GA','You probably already know that Georgia is known as the Peach State. You may already know that the state capital is Atlanta. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Hawaii',15,'HI','You probably already know that Hawaii is known as the Aloha State. You may already know that the state capital is Honolulu. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Idaho',17,'ID','You probably already know that Idaho is known as the Gem State. You may already know that the state capital is Boise. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Illinois',18,'IL','You probably already know that Illinois is known as the Prairie State. You may already know that the state capital is Springfield. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('indiana',19,'IN','You probably already know that Indiana is known as the Crossroads of America. You may already know that the state capital is Indianapolis. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Iowa',16,'IA','You probably already know that Iowa is known as the Hawkeye State. You may already know that the state capital is Des Moines. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Kansas',21,'KS','You probably already know that Kansas is known as the Sunflower State. You may already know that the state capital is Topeka. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Kentucky',22,'KY','You probably already know that Kentucky is known as the Bluegrass State. You may already know that the state capital is Frankfort. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Louisiana',23,'LA','You probably already know that Louisiana is known as the Pelican State. You may already know that the state capital is Baton Rouge. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Maine',26,'ME','You probably already know that Maine is known as the Pine Tree State. You may already know that the state capital is Augusta. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Maryland',25,'MD','You probably already know that Maryland is known as the Old Line State. You may already know that the state capital is Annapolis. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Massachusetts',24,'MA','You probably already know that Massachusetts is known as the Bay State. You may already know that the state capital is Boston. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Michigan',27,'MI','You probably already know that Michigan is known as the Great Lakes State. You may already know that the state capital is Lansing. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Minnesota',28,'MN','You probably already know that Minnesota is known as the North Star State. You may already know that the state capital is St. Paul. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Mississippi',30,'MS','You probably already know that Mississippi is known as the Magnolia State. You may already know that the state capital is Jackson. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Missouri',29,'MO','You probably already know that Missouri is known as the Show Me State. You may already know that the state capital is Jefferson City. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Montana',31,'MT','You probably already know that Montana is known as the Treasure State . You may already know that the state capital is Helena. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Nebraska',34,'NE','You probably already know that Nebraska is known as the Cornhusker State. You may already know that the state capital is Lincoln. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Nevada',38,'NV','You probably already know that Nevada is known as the Silver State. You may already know that the state capital is Carson City. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('New Hampshire',35,'NH','You probably already know that New Hampshire is known as the Granite State. You may already know that the state capital is Concord. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('New Jersey',36,'NJ','You probably already know that New Jersey is known as the Garden State. You may already know that the state capital is Trenton. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('New Mexico',37,'NM','You probably already know that New Mexico is known as the The Land of Enchantment. You may already know that the state capital is Santa Fe. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('New York',39,'NY','You probably already know that New York is known as the Empire State. You may already know that the state capital is Albany. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('North Carolina',32,'NC','You probably already know that North Carolina is known as the Tar Heel State. You may already know that the state capital is Raleigh. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('North Dakota',33,'ND','You probably already know that North Dakota is known as the Peace Garden State. You may already know that the state capital is Bismarck. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Ohio',40,'OH','You probably already know that Ohio is known as the Buckeye State. You may already know that the state capital is Columbus. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Oklahoma',41,'OK','You probably already know that Oklahoma is known as the Sooner State. You may already know that the state capital is Oklahoma City. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Oregon',42,'OR','You probably already know that Oregon is known as the Beaver State. You may already know that the state capital is Salem. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Pennsylvania',43,'PA','You probably already know that Pennsylvania is known as the Keystone State. You may already know that the state capital is Harrisburg. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Puerto Rico',44,'PR','Puerto Rico SEO')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Rhode Island',45,'RI','You probably already know that Rhode Island is known as the Ocean State. You may already know that the state capital is Providence. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('South Carolina',46,'SC','You probably already know that South Carolina is known as the Palmetto State. You may already know that the state capital is Columbia. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('South Dakota',47,'SD','You probably already know that South Dakota is known as the Mount Rushmore State. You may already know that the state capital is Pierre. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Tennessee',48,'TN','You probably already know that Tennessee is known as the Volunteer State. You may already know that the state capital is Nashville. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Texas',49,'TX','You probably already know that Texas is known as the Lone Star State. You may already know that the state capital is Austin. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Utah',50,'UT','You probably already know that Utah is known as the Beehive State. You may already know that the state capital is Salt Lake City. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Vermont',52,'VT','You probably already know that Vermont is known as the Green Mountain State. You may already know that the state capital is Montpelier. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Virginia',51,'VA','You probably already know that Virginia is known as Old Dominion. You may already know that the state capital is Richmond. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Washington',53,'WA','You probably already know that Washington is known as the Evergreen State. You may already know that the state capital is Olympia. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('West Virginia',55,'WV','You probably already know that West Virginia is known as the Mountain State. You may already know that the state capital is Charleston. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Wisconsin',54,'WI','You probably already know that Wisconsin is known as the Badger State. You may already know that the state capital is Madison. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Wyoming',56,'WY','You probably already know that Wyoming is known as the Equality State. You may already know that the state capital is Cheyenne. But did you know that we list over {0} {1} in the state. With this many {1} to choose from you are sure to find one near your home or work. Just click on a city to the right for a list of {1} in your area. This is just one more way you can quickly find a {2} near you.')

INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Virgin Islands',70,'VI','')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Guam',71,'GU','')

INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Armed Forces Americas',60,'AA','')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Armed Forces East',61,'AE','')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('Armed Forces Pacific',62,'AP','')
INSERT INTO [STATE]([name],[stateid],[abbr],[description]) values ('International',63,'IT','')

SET identity_insert STATE off
END